package com.boxin.ims.modules.bi.recharge.dao;

import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.boxin.framework.base.dao.DaoHelper;

/**
 * @author Administrator
 * @date 2014-3-15
 * @function <p>数据分析Dao类 </p>
 */
@Service
public class BIRechargeDao{
	
	@Autowired
	protected DaoHelper daoHelper;

	
	/**
	 * 获得recharge  和member表中money值不同的
	 *@author xiaoqian
	 * @param params
	 * @return
	 * 2014-3-19下午4:51:02
	 */
	public List<Map<String,Object>> queryRechargeBymoney(){
		return daoHelper.queryForList("com.boxin.ims.bi.queryRechargeBymoney", null);
	}
	
	
	/**
	 * 通过记录查询用户到底有多少分
	 *@author xiaoqian
	 * @param params
	 * @return
	 * 2014-3-19下午4:51:02
	 */
	public List<Map<String,Object>> queryRechargeLogSumBynumber(Map<String,Object> params){
		return daoHelper.queryForList("com.boxin.ims.bi.queryRechargeLogSumBynumber", params);
	}
	
	/**
	 * 获得rechargeLogs
	 *@author xiaoqian
	 * @param params
	 * @return
	 * 2014-4-3下午2:37:02
	 */
	public List<Map<String,Object>> queryRechargeLogByUserId(Map<String,Object> params){
		return daoHelper.queryForList("com.boxin.ims.bi.queryRechargeLogByUserId", params);
	}
	
	/**
	 * 获的rechargelog  每月  数据
	 *@author xiaoqian
	 * @param params
	 * @return
	 * 2014-4-3下午3:37:16
	 */
	public List<Map<String,Object>> queryRechargeLogBymonth(Map<String,Object> params){
		return daoHelper.queryForList("com.boxin.ims.bi.queryRechargeLogBymonth", params);
	}
	
}
